Skip to content

Oracle PL/SQL Instructor-led Training

Free server access, Class recordings, Certification guidance, Job & Interview assistance, Course Completion Certificate

Uplatz

Summary

Price
£899 inc VAT
Or £74.92/mo. for 12 months...
Study method
Online + live classes
Duration
30 hours · Part-time or full-time
Qualification
No formal qualification
Certificates
  • Uplatz Certificate of Completion - Free
Additional info
  • Tutor is available to students

Add to basket or enquire

Overview

Oracle PL/SQL Course Overview

The Oracle PL/SQL course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language.

Versions supported 11gR2, 12cR2, 18c, 19c.
-------------------------------------------------------------------------------------------------------------------------------------

Who will the Course Benefit?

Oracle database administrators, software development personnel and database support staff who need to write PL/SQL scripts to enhance their productivity in manipulating data.
-----------------------------------------------------------------------------------------------------------------------------------

Course Objectives

To provide the skills needed to write stand-alone programs using the main features of Oracle's PL/SQL Programming Language.
-------------------------------------------------------------------------------------------------------------------------------------
This is a Oracle PL/SQL course by Uplatz.

Course media

Resources

  • Oracle Pl/SQL tutor led course syllabus - download

Description

Oracle PL/SQL Training Course

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: PL/SQL FUNDAMENTALS

  • What is PL/SQL?
  • Basic Elements
  • Variables and Constants
  • Data Types
  • Initialising Variables and Assigning Values
  • Using SQL Statements in Code
  • Generating Output to SQL or SQL Developer

Session 2: PROGRAM LOGIC

  • IF THEN ELSIF ELSE Statements
  • CASE Statements
  • The Basic Loop Construct
  • WHILE and FOR Loops
  • Nested and Labelled Loops
  • The GOTO Statement
  • The CONTINUE Statement

Session 3: USING CURSORS

  • What is a Cursor?
  • Implicit and Explicit Cursors
  • Cursor Operations
  • Declaring, Opening and Closing Cursors
  • Fetching Rows
  • Status Checking
  • Using Cursors FOR UPDATE
  • The Cursor FOR Loop
  • Parameterised Cursors

Oracle PL/SQL Training Course

Session 4: EXCEPTIONS AND NESTED BLOCKS

  • The EXCEPTION Section
  • Types of Exception
  • Handling Named System-Raised Exceptions
  • Handling Un-named System-Raised Exceptions
  • User-Declared Exceptions and Application Errors
  • WHEN OTHERS THEN NULL
  • Nested and Labelled Blocks
  • Propagation of Exceptions
  • Scope of Variables and Cursors
  • Scope of Goto Statements

Session 5: PL/SQL RECORDS AND INDEX-BY TABLES

  • Declaring Record Types
  • Handling PL/SQL Records
  • Nested Records
  • Declaring PL/SQL Index-By Tables or Associative Arrays
  • PL/SQL Table Built-in Functions
  • Manipulating PL/SQL Tables or Associative Arrays

Who is this course for?

Everyone

Requirements

None

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Certificates

Uplatz Certificate of Completion

Digital certificate - Included

Course Completion Certificate by Uplatz

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Web development courses, Oracle courses, Online courses